Between the key attribute and each non - key attribute bound to columns in the main dimension table 在鍵屬性與綁定到主維度表中各列的每個非鍵屬性之間定義。
Of a database dimension is the attribute to which all non - key attributes in the dimension are linked directly or indirectly 上圖所示的多維數(shù)據(jù)集有四個維度: route 、 service 、 time和measures 。
Between the attribute bound to foreign key in the secondary table and each non - key attribute bound to columns from the secondary table 在綁定到輔助表中外鍵的屬性與綁定到輔助表中各列的每個非鍵屬性之間定義。
For example , you might want to define a natural hierarchy , a custom sort order , or dimension granularity based on a non - key attribute 例如,您可能需要定義自然層次結(jié)構(gòu)、自定義排序順序或基于非鍵屬性的維度粒度。
If there are no defined relationships between attributes , analysis services will aggregate all non - key attributes from the key attribute 如果屬性之間沒有定義的關(guān)系,則analysis services將根據(jù)鍵屬性聚合所有非鍵屬性。
Notice the four attribute relationships that link the non - key attributes from the geography table to the key attribute from the geography table 請注意,用于將geography表的非鍵屬性鏈接到geography表的鍵屬性的四個成員屬性。
If the granularity attribute and the key attribute are different attributes , then non - key attributes must be linked , directly or indirectly , to the granularity attribute 將事務或數(shù)據(jù)快照從發(fā)布服務器移動到訂閱服務器,在訂閱服務器上,將它們應用于訂閱數(shù)據(jù)庫中的目標表。
When you define a dimension based on a star schema , which is where all dimension attributes are derived from the same relational table , an attribute relationship is automatically defined between the key attribute and each non - key attribute of the dimension 當您基于星型架構(gòu)(在該架構(gòu)中,所有維度屬性都派生自同一關(guān)系表)定義維度時,會在維度的鍵屬性與每個非鍵屬性之間自動定義屬性關(guān)系。